0

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6510698795319 394 1.1715 0


No Amazon API Requests Made.


App Debug - Total Time 1.6510698795319 seconds

Number Time From Start Name Description
1 0.4035758972168 Initialise Initialise FSB Function
2 0.40661883354187 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45498204231262 Start of getCategoryListByGroup Function Before first category groups query
4 0.45595502853394 After initial query Before first category groups query
5 0.45595598220825 Get Category List for Group Before the call to getCategoryList function
6 0.45595788955688 Start of GetCategoryList function Start of the function
7 0.4559600353241 Before getting categories Query to get specific category list
8 0.45682883262634 After getting categories Query to get specific category list
9 0.45683002471924 Before getting category custom Before call to function getCategoryCustom
10 0.47224903106689 After getting category custom After call to function getCategoryCustom
11 0.47225093841553 Before getting category custom Before call to function getCategoryCustom
12 0.48089981079102 After getting category custom After call to function getCategoryCustom
13 0.48090100288391 Before getting category custom Before call to function getCategoryCustom
14 0.48558592796326 After getting category custom After call to function getCategoryCustom
15 0.48558688163757 Before getting category custom Before call to function getCategoryCustom
16 0.48874402046204 After getting category custom After call to function getCategoryCustom
17 0.48874497413635 Before getting category custom Before call to function getCategoryCustom
18 0.49184393882751 After getting category custom After call to function getCategoryCustom
19 0.49184489250183 Before getting category custom Before call to function getCategoryCustom
20 0.49513483047485 After getting category custom After call to function getCategoryCustom
21 0.49513602256775 End of GetCategoryList function End of the function
22 0.49513983726501 Get Category List for Group Before the call to getCategoryList function
23 0.49514198303223 Start of GetCategoryList function Start of the function
24 0.49514293670654 Before getting categories Query to get specific category list
25 0.49548602104187 End of getCategoryListByGroup Function Before return()
26 1.4049518108368 App Controller End End of the App controller (called before the controller of every page)
27 1.5281908512115 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.5292148590088 Before Get Options Before the call to getOptions in the tpl class
29 1.5704419612885 After Get Options After the call to getOptions in the tpl class
30 1.5704739093781 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.6510620117188 Finalizing debug Before the debug is output to the page.
32 1.6510698795319 End of App This is the end of the app logging, final timestamp


Query Debug - 394 Database Queries. Total time 1.1715 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00076198577880859
SELECT parameter, value FROM parameters
2 0.0055 0.0054800510406494
SELECT * FROM `bad_bots`
3 0.0004 0.0003509521484375
SET time_zone = 'Europe/London'
4 0.0014 0.001410961151123
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0015 0.0014598369598389
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.102\";}'
6 0.0013 0.0012571811676025
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1752181086'
7 0.0019 0.0019309520721436
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047802925109863
UPDATE autorun SET lastrun = '2025-07-10 20:58:06' WHERE id = '15'
9 0.0005 0.00053811073303223
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0014 0.0014262199401855
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0004 0.00039005279541016
SELECT * FROM pages WHERE id = 52
12 0.0031 0.0030739307403564
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0443 0.044305086135864
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00055122375488281
SELECT * FROM pages WHERE pagename = 'search'
15 0.0010 0.00096678733825684
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0009 0.00085902214050293
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0056 0.0056319236755371
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0009 0.00094485282897949
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0006 0.00064396858215332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00031089782714844
SELECT id FROM categories WHERE parent_id = '26'
21 0.0048 0.0047800540924072
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0009 0.00090384483337402
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0010 0.0010039806365967
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0008 0.00083303451538086
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00031781196594238
SELECT * FROM categorygroups WHERE id = '1'
26 0.0031 0.0030980110168457
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0004 0.00037288665771484
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0003 0.00030994415283203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00032496452331543
SELECT id FROM categories WHERE parent_id = '27'
30 0.0031 0.0030779838562012
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0004 0.00040793418884277
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0004 0.00039100646972656
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0004 0.00035309791564941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.0002899169921875
SELECT * FROM categorygroups WHERE id = '1'
35 0.0011 0.0011320114135742
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0003 0.00031709671020508
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00029516220092773
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.0003209114074707
SELECT id FROM categories WHERE parent_id = '28'
39 0.0013 0.0012760162353516
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0004 0.00036311149597168
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0004 0.00036001205444336
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0003 0.00031614303588867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.00028610229492188
SELECT * FROM categorygroups WHERE id = '1'
44 0.0004 0.00038719177246094
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0003 0.00033187866210938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0003 0.00028491020202637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00030016899108887
SELECT id FROM categories WHERE parent_id = '29'
48 0.0005 0.00045609474182129
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0004 0.00035500526428223
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0004 0.00035214424133301
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0004 0.00037002563476562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00030303001403809
SELECT * FROM categorygroups WHERE id = '1'
53 0.0004 0.0003960132598877
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.00031900405883789
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00028586387634277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00030088424682617
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00046277046203613
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0003 0.00032997131347656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0003 0.00034403800964355
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0003 0.00031304359436035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00031304359436035
SELECT * FROM categorygroups WHERE id = '1'
62 0.0004 0.00040698051452637
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.0003349781036377
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00042986869812012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.0003049373626709
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00050520896911621
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0003 0.00033092498779297
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0003 0.00034403800964355
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0003 0.0003209114074707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00028705596923828
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00033998489379883
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0020 0.0020060539245605
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0008 0.00083780288696289
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00047492980957031
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0007 0.00073695182800293
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0009 0.00093913078308105
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00056695938110352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.9000 0.90002608299255
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.102') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.102') <= INET_ATON(ip_end)
79 0.0015 0.001514196395874
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0008 0.00077605247497559
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0004 0.00039005279541016
SELECT * FROM pages WHERE pagename = 'search'
82 0.0048 0.0048379898071289
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0014 0.001366138458252
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0010 0.00097107887268066
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0048 0.0047500133514404
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0014 0.0013580322265625
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00037097930908203
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0008 0.0008089542388916
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'easehold bote cafe hermetique botes et coffrets the et cafe', NOW(), '216.73.216.102'
89 0.0005 0.00052094459533691
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0003 0.00034213066101074
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0040 0.0039708614349365
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
92 0.0004 0.00035190582275391
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
93 0.0003 0.00034594535827637
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
94 0.0003 0.00033378601074219
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
95 0.0069 0.0068581104278564
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
96 0.0003 0.00028014183044434
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
97 0.0002 0.00024104118347168
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
98 0.0007 0.00067901611328125
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0004 0.00035381317138672
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0040 0.003972053527832
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
101 0.0003 0.00025391578674316
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
102 0.0002 0.00023412704467773
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
103 0.0003 0.00032401084899902
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0066 0.0065820217132568
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
105 0.0003 0.00028705596923828
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
106 0.0002 0.00024199485778809
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
107 0.0003 0.00031495094299316
SELECT * FROM products WHERE id = '3673'
108 0.0009 0.00086498260498047
SELECT * FROM productimages WHERE product_id = '3673' ORDER BY sortorder ASC
109 0.0008 0.00079202651977539
SELECT * FROM product_image_select WHERE product_id = '3673'
110 0.0006 0.00059294700622559
SELECT * FROM productcustomimages WHERE product_id = '3673'
111 0.0013 0.0013020038604736
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3673' AND a.name = n.originalname
112 0.0007 0.00072908401489258
SELECT * FROM productoffers WHERE product_id = '3673' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '3673' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = 3673
                ORDER BY price ASC LIMIT 1
115 0.0003 0.00032210350036621
SELECT value FROM productattributes
                WHERE product_id = '3673'
                AND name = 'ListPriceAmount'
116 0.0003 0.00028204917907715
SELECT value FROM productattributes WHERE product_id = '3673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0003 0.00031399726867676
SELECT * FROM products WHERE id = '3674'
118 0.0003 0.00028491020202637
SELECT * FROM productimages WHERE product_id = '3674' ORDER BY sortorder ASC
119 0.0004 0.00042200088500977
SELECT * FROM product_image_select WHERE product_id = '3674'
120 0.0003 0.00025415420532227
SELECT * FROM productcustomimages WHERE product_id = '3674'
121 0.0006 0.00063991546630859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3674' AND a.name = n.originalname
122 0.0003 0.00029993057250977
SELECT * FROM productoffers WHERE product_id = '3674' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0002 0.00024890899658203
SELECT * FROM productoffers
                WHERE product_id = '3674' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0002 0.00022220611572266
SELECT * FROM productoffers
                WHERE product_id = 3674
                ORDER BY price ASC LIMIT 1
125 0.0002 0.0002288818359375
SELECT value FROM productattributes
                WHERE product_id = '3674'
                AND name = 'ListPriceAmount'
126 0.0002 0.0002439022064209
SELECT value FROM productattributes WHERE product_id = '3674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00031399726867676
SELECT * FROM products WHERE id = '3675'
128 0.0003 0.00029706954956055
SELECT * FROM productimages WHERE product_id = '3675' ORDER BY sortorder ASC
129 0.0004 0.00041913986206055
SELECT * FROM product_image_select WHERE product_id = '3675'
130 0.0003 0.00030207633972168
SELECT * FROM productcustomimages WHERE product_id = '3675'
131 0.0007 0.00067591667175293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3675' AND a.name = n.originalname
132 0.0003 0.00030279159545898
SELECT * FROM productoffers WHERE product_id = '3675' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '3675' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = 3675
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00026702880859375
SELECT value FROM productattributes
                WHERE product_id = '3675'
                AND name = 'ListPriceAmount'
136 0.0003 0.00031900405883789
SELECT value FROM productattributes WHERE product_id = '3675' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = '3682'
138 0.0004 0.00035691261291504
SELECT * FROM productimages WHERE product_id = '3682' ORDER BY sortorder ASC
139 0.0003 0.00028300285339355
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3682' AND p.id = pi.product_id ORDER BY pi.sortorder
140 0.0004 0.00042319297790527
SELECT * FROM product_image_select WHERE product_id = '3682'
141 0.0003 0.00027990341186523
SELECT * FROM productcustomimages WHERE product_id = '3682'
142 0.0004 0.00038695335388184
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3682'
                GROUP BY o.product_id
143 0.0012 0.0012309551239014
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3682'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
144 0.0003 0.00034093856811523
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3682
145 0.0007 0.00066900253295898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3682' AND a.name = n.originalname
146 0.0002 0.0002439022064209
SELECT * FROM productoffers WHERE product_id = '3682' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0002 0.00023984909057617
SELECT * FROM productoffers
                WHERE product_id = '3682' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = 3682
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00025296211242676
SELECT value FROM productattributes
                WHERE product_id = '3682'
                AND name = 'ListPriceAmount'
150 0.0003 0.00026297569274902
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3682'
                GROUP BY o.product_id
151 0.0004 0.00038814544677734
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3682'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
152 0.0003 0.00026202201843262
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3682
153 0.0003 0.00034594535827637
SELECT value FROM productattributes WHERE product_id = '3682' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0004 0.00038003921508789
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3682'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
155 0.0003 0.00027203559875488
SELECT * FROM products WHERE parent_id = '3682'
156 0.0004 0.00035905838012695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4890' AND a.name = n.originalname
157 0.0003 0.0003058910369873
SELECT * FROM productoffers WHERE product_id = '4890' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0003 0.00028204917907715
SELECT * FROM productoffers
                WHERE product_id = '4890' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = 4890
                ORDER BY price ASC LIMIT 1
160 0.0002 0.00023198127746582
SELECT value FROM productattributes
                WHERE product_id = '4890'
                AND name = 'ListPriceAmount'
161 0.0002 0.00024294853210449
SELECT * FROM products WHERE id = '3687'
162 0.0003 0.00033712387084961
SELECT * FROM productimages WHERE product_id = '3687' ORDER BY sortorder ASC
163 0.0004 0.00044584274291992
SELECT * FROM product_image_select WHERE product_id = '3687'
164 0.0003 0.00028300285339355
SELECT * FROM productcustomimages WHERE product_id = '3687'
165 0.0006 0.00055384635925293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3687' AND a.name = n.originalname
166 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '3687' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0003 0.00025081634521484
SELECT * FROM productoffers
                WHERE product_id = '3687' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0003 0.00027084350585938
SELECT value FROM productattributes WHERE product_id = '3687' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0003 0.00032210350036621
SELECT * FROM products WHERE id = '3690'
170 0.0003 0.00032305717468262
SELECT * FROM productimages WHERE product_id = '3690' ORDER BY sortorder ASC
171 0.0003 0.00029182434082031
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3690' AND p.id = pi.product_id ORDER BY pi.sortorder
172 0.0004 0.00042915344238281
SELECT * FROM product_image_select WHERE product_id = '3690'
173 0.0003 0.00026202201843262
SELECT * FROM productcustomimages WHERE product_id = '3690'
174 0.0004 0.00035691261291504
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3690'
                GROUP BY o.product_id
175 0.0004 0.00040817260742188
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3690'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
176 0.0002 0.00024795532226562
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3690
177 0.0005 0.00053191184997559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3690' AND a.name = n.originalname
178 0.0002 0.00024294853210449
SELECT * FROM productoffers WHERE product_id = '3690' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0002 0.00024080276489258
SELECT * FROM productoffers
                WHERE product_id = '3690' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0002 0.00021886825561523
SELECT * FROM productoffers
                WHERE product_id = 3690
                ORDER BY price ASC LIMIT 1
181 0.0003 0.00025486946105957
SELECT value FROM productattributes
                WHERE product_id = '3690'
                AND name = 'ListPriceAmount'
182 0.0003 0.00025701522827148
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3690'
                GROUP BY o.product_id
183 0.0004 0.00038003921508789
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3690'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
184 0.0002 0.00024008750915527
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3690
185 0.0003 0.00033187866210938
SELECT value FROM productattributes WHERE product_id = '3690' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0004 0.0003659725189209
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3690'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
187 0.0003 0.00030303001403809
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3690'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
188 0.0003 0.00026297569274902
SELECT * FROM products WHERE parent_id = '3690'
189 0.0006 0.00060510635375977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4190' AND a.name = n.originalname
190 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '4190' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0003 0.00027084350585938
SELECT * FROM productoffers
                WHERE product_id = '4190' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = 4190
                ORDER BY price ASC LIMIT 1
193 0.0003 0.00030112266540527
SELECT value FROM productattributes
                WHERE product_id = '4190'
                AND name = 'ListPriceAmount'
194 0.0003 0.00030303001403809
SELECT * FROM products WHERE id = '3704'
195 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '3704' ORDER BY sortorder ASC
196 0.0005 0.00045108795166016
SELECT * FROM product_image_select WHERE product_id = '3704'
197 0.0003 0.00026583671569824
SELECT * FROM productcustomimages WHERE product_id = '3704'
198 0.0006 0.00059199333190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3704' AND a.name = n.originalname
199 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '3704' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '3704' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = 3704
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00025105476379395
SELECT value FROM productattributes
                WHERE product_id = '3704'
                AND name = 'ListPriceAmount'
203 0.0003 0.00027894973754883
SELECT value FROM productattributes WHERE product_id = '3704' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00039911270141602
SELECT * FROM products WHERE id = '3706'
205 0.0003 0.00034213066101074
SELECT * FROM productimages WHERE product_id = '3706' ORDER BY sortorder ASC
206 0.0004 0.00041985511779785
SELECT * FROM product_image_select WHERE product_id = '3706'
207 0.0003 0.0002591609954834
SELECT * FROM productcustomimages WHERE product_id = '3706'
208 0.0005 0.00051403045654297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3706' AND a.name = n.originalname
209 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '3706' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = '3706' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.00023579597473145
SELECT * FROM productoffers
                WHERE product_id = 3706
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00024986267089844
SELECT value FROM productattributes
                WHERE product_id = '3706'
                AND name = 'ListPriceAmount'
213 0.0003 0.00026106834411621
SELECT value FROM productattributes WHERE product_id = '3706' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0003 0.00033187866210938
SELECT * FROM products WHERE id = '4316'
215 0.0003 0.00032591819763184
SELECT * FROM productimages WHERE product_id = '4316' ORDER BY sortorder ASC
216 0.0004 0.00042605400085449
SELECT * FROM product_image_select WHERE product_id = '4316'
217 0.0003 0.00026512145996094
SELECT * FROM productcustomimages WHERE product_id = '4316'
218 0.0005 0.0005180835723877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4316' AND a.name = n.originalname
219 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '4316' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '4316' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = 4316
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00024700164794922
SELECT value FROM productattributes
                WHERE product_id = '4316'
                AND name = 'ListPriceAmount'
223 0.0003 0.00027799606323242
SELECT value FROM productattributes WHERE product_id = '4316' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0003 0.00032591819763184
SELECT * FROM products WHERE id = '3728'
225 0.0003 0.00031900405883789
SELECT * FROM productimages WHERE product_id = '3728' ORDER BY sortorder ASC
226 0.0005 0.00049495697021484
SELECT * FROM product_image_select WHERE product_id = '3728'
227 0.0003 0.00026988983154297
SELECT * FROM productcustomimages WHERE product_id = '3728'
228 0.0005 0.00054693222045898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3728' AND a.name = n.originalname
229 0.0003 0.00030422210693359
SELECT * FROM productoffers WHERE product_id = '3728' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = '3728' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = 3728
                ORDER BY price ASC LIMIT 1
232 0.0003 0.00027799606323242
SELECT value FROM productattributes
                WHERE product_id = '3728'
                AND name = 'ListPriceAmount'
233 0.0003 0.00030422210693359
SELECT value FROM productattributes WHERE product_id = '3728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0003 0.00034308433532715
SELECT * FROM products WHERE id = '3745'
235 0.0003 0.0003361701965332
SELECT * FROM productimages WHERE product_id = '3745' ORDER BY sortorder ASC
236 0.0004 0.00043296813964844
SELECT * FROM product_image_select WHERE product_id = '3745'
237 0.0003 0.00028896331787109
SELECT * FROM productcustomimages WHERE product_id = '3745'
238 0.0007 0.0006709098815918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3745' AND a.name = n.originalname
239 0.0004 0.0003659725189209
SELECT * FROM productoffers WHERE product_id = '3745' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = '3745' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = 3745
                ORDER BY price ASC LIMIT 1
242 0.0003 0.00027322769165039
SELECT value FROM productattributes
                WHERE product_id = '3745'
                AND name = 'ListPriceAmount'
243 0.0003 0.00030708312988281
SELECT value FROM productattributes WHERE product_id = '3745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = '3737'
245 0.0003 0.00031805038452148
SELECT * FROM productimages WHERE product_id = '3737' ORDER BY sortorder ASC
246 0.0005 0.0004730224609375
SELECT * FROM product_image_select WHERE product_id = '3737'
247 0.0003 0.00030303001403809
SELECT * FROM productcustomimages WHERE product_id = '3737'
248 0.0008 0.00083398818969727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3737' AND a.name = n.originalname
249 0.0003 0.00033402442932129
SELECT * FROM productoffers WHERE product_id = '3737' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0003 0.00028681755065918
SELECT * FROM productoffers
                WHERE product_id = '3737' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0003 0.00026512145996094
SELECT value FROM productattributes WHERE product_id = '3737' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0003 0.00034117698669434
SELECT * FROM products WHERE id = '3733'
253 0.0003 0.00031495094299316
SELECT * FROM productimages WHERE product_id = '3733' ORDER BY sortorder ASC
254 0.0005 0.0004880428314209
SELECT * FROM product_image_select WHERE product_id = '3733'
255 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '3733'
256 0.0008 0.00083208084106445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3733' AND a.name = n.originalname
257 0.0003 0.00031518936157227
SELECT * FROM productoffers WHERE product_id = '3733' AND merchantid = 'A1X6FK5RDHNB96'
258 0.0003 0.00026512145996094
SELECT * FROM productoffers
                WHERE product_id = '3733' AND price > 0
                ORDER BY price ASC LIMIT 1
259 0.0003 0.00025486946105957
SELECT value FROM productattributes WHERE product_id = '3733' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0003 0.00031304359436035
SELECT * FROM products WHERE id = '3734'
261 0.0003 0.00028896331787109
SELECT * FROM productimages WHERE product_id = '3734' ORDER BY sortorder ASC
262 0.0004 0.00043606758117676
SELECT * FROM product_image_select WHERE product_id = '3734'
263 0.0003 0.00025105476379395
SELECT * FROM productcustomimages WHERE product_id = '3734'
264 0.0008 0.0007929801940918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3734' AND a.name = n.originalname
265 0.0003 0.0002899169921875
SELECT * FROM productoffers WHERE product_id = '3734' AND merchantid = 'A1X6FK5RDHNB96'
266 0.0003 0.00029206275939941
SELECT * FROM productoffers
                WHERE product_id = '3734' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0004 0.00037312507629395
SELECT * FROM productoffers
                WHERE product_id = 3734
                ORDER BY price ASC LIMIT 1
268 0.0003 0.00026297569274902
SELECT value FROM productattributes
                WHERE product_id = '3734'
                AND name = 'ListPriceAmount'
269 0.0003 0.00028705596923828
SELECT value FROM productattributes WHERE product_id = '3734' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0003 0.00032901763916016
SELECT * FROM products WHERE id = '3741'
271 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '3741' ORDER BY sortorder ASC
272 0.0004 0.00042605400085449
SELECT * FROM product_image_select WHERE product_id = '3741'
273 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '3741'
274 0.0009 0.00089597702026367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3741' AND a.name = n.originalname
275 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '3741' AND merchantid = 'A1X6FK5RDHNB96'
276 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '3741' AND price > 0
                ORDER BY price ASC LIMIT 1
277 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = 3741
                ORDER BY price ASC LIMIT 1
278 0.0002 0.00024795532226562
SELECT value FROM productattributes
                WHERE product_id = '3741'
                AND name = 'ListPriceAmount'
279 0.0003 0.00026106834411621
SELECT value FROM productattributes WHERE product_id = '3741' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0003 0.00033092498779297
SELECT * FROM products WHERE id = '3735'
281 0.0003 0.0003049373626709
SELECT * FROM productimages WHERE product_id = '3735' ORDER BY sortorder ASC
282 0.0004 0.00042200088500977
SELECT * FROM product_image_select WHERE product_id = '3735'
283 0.0003 0.0002598762512207
SELECT * FROM productcustomimages WHERE product_id = '3735'
284 0.0005 0.00052094459533691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3735' AND a.name = n.originalname
285 0.0003 0.00028705596923828
SELECT * FROM productoffers WHERE product_id = '3735' AND merchantid = 'A1X6FK5RDHNB96'
286 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '3735' AND price > 0
                ORDER BY price ASC LIMIT 1
287 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = 3735
                ORDER BY price ASC LIMIT 1
288 0.0003 0.00028395652770996
SELECT value FROM productattributes
                WHERE product_id = '3735'
                AND name = 'ListPriceAmount'
289 0.0003 0.00025510787963867
SELECT value FROM productattributes WHERE product_id = '3735' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0004 0.00036191940307617
SELECT * FROM products WHERE id = '3739'
291 0.0004 0.00036096572875977
SELECT * FROM productimages WHERE product_id = '3739' ORDER BY sortorder ASC
292 0.0004 0.00044488906860352
SELECT * FROM product_image_select WHERE product_id = '3739'
293 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '3739'
294 0.0006 0.00057315826416016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3739' AND a.name = n.originalname
295 0.0003 0.00031018257141113
SELECT * FROM productoffers WHERE product_id = '3739' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '3739' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = 3739
                ORDER BY price ASC LIMIT 1
298 0.0003 0.00025415420532227
SELECT value FROM productattributes
                WHERE product_id = '3739'
                AND name = 'ListPriceAmount'
299 0.0003 0.00026106834411621
SELECT value FROM productattributes WHERE product_id = '3739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300 0.0003 0.00033187866210938
SELECT * FROM products WHERE id = '3744'
301 0.0003 0.0003049373626709
SELECT * FROM productimages WHERE product_id = '3744' ORDER BY sortorder ASC
302 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '3744'
303 0.0003 0.00026988983154297
SELECT * FROM productcustomimages WHERE product_id = '3744'
304 0.0006 0.00062704086303711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
305 0.0003 0.00030899047851562
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
306 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
308 0.0002 0.00023698806762695
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
309 0.0003 0.00028300285339355
SELECT value FROM productattributes WHERE product_id = '3744' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0011 0.0010550022125244
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3673' ORDER BY timestamp DESC
311 0.0002 0.00024890899658203
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3674' ORDER BY timestamp DESC
312 0.0002 0.00023794174194336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3675' ORDER BY timestamp DESC
313 0.0003 0.00026392936706543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3682' ORDER BY timestamp DESC
314 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3687' ORDER BY timestamp DESC
315 0.0002 0.00024795532226562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3690' ORDER BY timestamp DESC
316 0.0002 0.00024795532226562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3704' ORDER BY timestamp DESC
317 0.0002 0.00024104118347168
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3706' ORDER BY timestamp DESC
318 0.0003 0.00028085708618164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4316' ORDER BY timestamp DESC
319 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3728' ORDER BY timestamp DESC
320 0.0003 0.0002591609954834
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3745' ORDER BY timestamp DESC
321 0.0002 0.00024890899658203
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3737' ORDER BY timestamp DESC
322 0.0002 0.00023698806762695
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3733' ORDER BY timestamp DESC
323 0.0002 0.00023913383483887
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3734' ORDER BY timestamp DESC
324 0.0002 0.00021696090698242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3741' ORDER BY timestamp DESC
325 0.0002 0.00023698806762695
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3735' ORDER BY timestamp DESC
326 0.0002 0.00023794174194336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3739' ORDER BY timestamp DESC
327 0.0002 0.00023412704467773
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3744' ORDER BY timestamp DESC
328 0.0009 0.00087618827819824
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
329 0.0007 0.00073003768920898
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
330 0.0002 0.00024604797363281
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
331 0.0116 0.011577129364014
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
332 0.0009 0.00090217590332031
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
333 0.0004 0.00037193298339844
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
334 0.0004 0.00043582916259766
SELECT * FROM products WHERE id = 1626
335 0.0003 0.00031805038452148
SELECT * FROM products WHERE id = 4041
336 0.0003 0.00030303001403809
SELECT * FROM products WHERE id = 4312
337 0.0003 0.0003049373626709
SELECT * FROM products WHERE id = 777
338 0.0003 0.00033092498779297
SELECT * FROM products WHERE id = 3881
339 0.0003 0.00030708312988281
SELECT * FROM products WHERE id = 4213
340 0.0003 0.00033903121948242
SELECT * FROM products WHERE id = '1626'
341 0.0004 0.00036501884460449
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
342 0.0006 0.00056004524230957
SELECT * FROM product_image_select WHERE product_id = '1626'
343 0.0003 0.00034189224243164
SELECT * FROM productcustomimages WHERE product_id = '1626'
344 0.0008 0.00076699256896973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
345 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
346 0.0006 0.00062203407287598
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
347 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
348 0.0004 0.00040292739868164
SELECT * FROM products WHERE id = '4041'
349 0.0003 0.00032687187194824
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
350 0.0005 0.00047206878662109
SELECT * FROM product_image_select WHERE product_id = '4041'
351 0.0003 0.00027608871459961
SELECT * FROM productcustomimages WHERE product_id = '4041'
352 0.0007 0.00069999694824219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
353 0.0003 0.00032591819763184
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
354 0.0003 0.00031399726867676
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
355 0.0003 0.00027990341186523
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = '4312'
357 0.0003 0.00032186508178711
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
358 0.0005 0.00048589706420898
SELECT * FROM product_image_select WHERE product_id = '4312'
359 0.0003 0.00030994415283203
SELECT * FROM productcustomimages WHERE product_id = '4312'
360 0.0007 0.00069403648376465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
361 0.0004 0.00039792060852051
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
362 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
363 0.0003 0.00032901763916016
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364 0.0004 0.00035595893859863
SELECT * FROM products WHERE id = '777'
365 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
366 0.0005 0.00050592422485352
SELECT * FROM product_image_select WHERE product_id = '777'
367 0.0003 0.00031614303588867
SELECT * FROM productcustomimages WHERE product_id = '777'
368 0.0008 0.00079107284545898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
369 0.0004 0.00040197372436523
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
370 0.0003 0.00028181076049805
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
371 0.0003 0.0002748966217041
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372 0.0004 0.00037193298339844
SELECT * FROM products WHERE id = '3881'
373 0.0004 0.00038886070251465
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
374 0.0005 0.00052404403686523
SELECT * FROM product_image_select WHERE product_id = '3881'
375 0.0004 0.00040411949157715
SELECT * FROM productcustomimages WHERE product_id = '3881'
376 0.0008 0.00081491470336914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
377 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
378 0.0003 0.00026679039001465
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
379 0.0003 0.00034117698669434
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
380 0.0005 0.00045585632324219
SELECT * FROM products WHERE id = '4213'
381 0.0004 0.00039386749267578
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
382 0.0006 0.00056004524230957
SELECT * FROM product_image_select WHERE product_id = '4213'
383 0.0004 0.00036716461181641
SELECT * FROM productcustomimages WHERE product_id = '4213'
384 0.0009 0.00087094306945801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
385 0.0004 0.00037693977355957
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
386 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
387 0.0003 0.00027298927307129
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
388 0.0011 0.0010919570922852
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
389 0.0005 0.00049901008605957
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
390 0.0016 0.0016348361968994
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
391 0.0009 0.00086712837219238
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
392 0.0004 0.00035595893859863
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
393 0.0006 0.00057220458984375
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
394 0.0005 0.00046896934509277
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'